﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using nplJobsCommon.JobSeeker;
using nplJobs.DB;
using System.Data;


namespace nplJobsDAL.Select
{
    public class SelectAlertFrequency
    {
        public static List<AlertFrequency> GetList()
        {
            CustomParameterList cpList = new CustomParameterList();

            object paramval = null;
            DBHelper db = new DBHelper();
            DataTable dt = db.ExecuteQueryToDataTable(cpList.ParameterNames, cpList.ParameterValues, cpList.ParameterTypes, ref paramval, null, "spJobAlertFrequency");

            List<AlertFrequency> results = new List<AlertFrequency>();
            foreach (DataRow dr in dt.Rows)
            {
                AlertFrequency objJobList = new AlertFrequency();

                MapperBase.GetInstance().MapItem(objJobList, dr); ;
                results.Add(objJobList);
            }
            return results;

        }
    }
    
}
